`:top

`!SQL:2016`! or `!`F33f`_`[ISO/IEC 9075:2016`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=ISO_9075]`_`f`! (under the general title "Information technology – Database languages – SQL") is the eighth revision of the `F33f`_`[ISO`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=International_Organization_for_Standardization]`_`f (1987) and `F33f`_`[ANSI`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=ANSI]`_`f (1986) standard for the `F33f`_`[SQL`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=SQL]`_`f `F33f`_`[database`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Database]`_`f `F33f`_`[query language`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Query_language]`_`f. It was formally adopted in December 2016.`:cite-ref-1[`F5bf`_`[1`#cite-note-1]`_`f] The standard consists of 9 parts which are described in some detail in `F33f`_`[SQL`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=SQL]`_`f. The next version is `F33f`_`[SQL:2023`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=SQL:2023]`_`f.

>>Contents

• `F0af`_`[New features`#new-features]`_`f

• `F0af`_`[See also`#see-also]`_`f

• `F0af`_`[References`#references]`_`f

• `F0af`_`[External links`#external-links]`_`f

-─

>>New features

SQL:2016 introduced 44 new optional features.`:cite-ref-2[`F5bf`_`[2`#cite-note-2]`_`f] 22 of them belong to the JSON functionality, ten more are related to polymorphic table functions. The additions to the standard include:

• `F33f`_`[JSON`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=JSON]`_`f: Functions to create JSON documents, to access parts of JSON documents and to check whether a string contains valid JSON data

• Row Pattern Recognition: Matching a sequence of rows against a `F33f`_`[regular expression`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Regular_expression]`_`f pattern

• Date and time formatting and parsing

• LISTAGG: A function to transform values from a group of rows into a delimited string

• Polymorphic table functions: table functions without predefined return type

• New data type DECFLOAT

>>See also

Wikibooks has a book on the topic of:

Structured Query Language

• `F33f`_`[Structured Query Language`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Structured_Query_Language]`_`f

>>References

`:cite-note-1`!1.`! `F0af`_`[↑`#cite-ref-1]`_`f "ISO/IEC 9075, 13249, and others". Retrieved 2017-03-15.

`:cite-note-2`!2.`! `F0af`_`[↑`#cite-ref-2]`_`f "What's New in SQL:2016". Retrieved 2017-06-16.

>>External links

• "SQL:2016", `*Catalogue`* (webshop), ISO.

• ISO/IEC TR 19075-5:2016: Row Pattern Recognition in SQL

• ISO/IEC TR 19075-6:2017: SQL support for JavaScript Object Notation (JSON)

• ISO/IEC TR 19075-7:2017: Polymorphic table functions in SQL

`c`F0af`_`[↑ Back to top`#top]`_`f`a